# phpMyAdmin SQL Dump
# version 2.5.7
# http://www.phpmyadmin.net
#
# Host: localhost
# Generatie Tijd: 23 Mar 2006 om 17:43
# Server versie: 4.1.15
# PHP Versie: 4.4.2-1
# 
# Database : `wwmental`
# 

# --------------------------------------------------------

#
# Tabel structuur voor tabel `ldu_i_autotext`
#

DROP TABLE IF EXISTS `ldu_i_autotext`;
CREATE TABLE `ldu_i_autotext` (
  `atid` int(11) NOT NULL auto_increment,
  `did` int(11) NOT NULL default '0',
  `minscore` int(11) NOT NULL default '0',
  `maxscore` int(11) NOT NULL default '0',
  `atext` text,
  PRIMARY KEY  (`atid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

# --------------------------------------------------------

#
# Tabel structuur voor tabel `ldu_i_dimensions`
#

DROP TABLE IF EXISTS `ldu_i_dimensions`;
CREATE TABLE `ldu_i_dimensions` (
  `did` int(11) NOT NULL auto_increment,
  `dname` varchar(64) NOT NULL default '',
  `ddescription` text,
  `iid` int(11) NOT NULL default '0',
  `minscore` int(11) NOT NULL default '0',
  `maxscore` int(11) NOT NULL default '0',
  PRIMARY KEY  (`did`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

# --------------------------------------------------------

#
# Tabel structuur voor tabel `ldu_i_items`
#

DROP TABLE IF EXISTS `ldu_i_items`;
CREATE TABLE `ldu_i_items` (
  `itid` int(11) NOT NULL auto_increment,
  `itname` varchar(64) NOT NULL default '',
  `ittext` text,
  `iid` int(11) NOT NULL default '0',
  `did` int(11) NOT NULL default '0',
  `itorder` int(11) NOT NULL default '0',
  `page` int(11) NOT NULL default '0',
  PRIMARY KEY  (`itid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

# --------------------------------------------------------

#
# Tabel structuur voor tabel `ldu_i_itemvalues`
#

DROP TABLE IF EXISTS `ldu_i_itemvalues`;
CREATE TABLE `ldu_i_itemvalues` (
  `ivid` int(11) NOT NULL auto_increment,
  `itid` int(11) NOT NULL default '0',
  `label` varchar(64) NOT NULL default '',
  `value` int(11) NOT NULL default '0',
  PRIMARY KEY  (`ivid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

# --------------------------------------------------------

#
# Tabel structuur voor tabel `ldu_i_reports`
#

DROP TABLE IF EXISTS `ldu_i_reports`;
CREATE TABLE `ldu_i_reports` (
  `rid` int(11) NOT NULL auto_increment,
  `rname` varchar(64) NOT NULL default '',
  `rtext` text,
  `iid` int(11) NOT NULL default '0',
  PRIMARY KEY  (`rid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

# --------------------------------------------------------

#
# Tabel structuur voor tabel `ldu_instruments`
#

DROP TABLE IF EXISTS `ldu_instruments`;
CREATE TABLE `ldu_instruments` (
  `iid` int(11) NOT NULL auto_increment,
  `iname` varchar(64) NOT NULL default '',
  `idescription` text,
  `iinstructions` text,
  `itype` varchar(64) NOT NULL default '',
  `creationdate` int(11) NOT NULL default '0',
  `normed` tinyint(4) NOT NULL default '0',
  `copyright` varchar(64) default NULL,
  `active` tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (`iid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;